﻿CREATE TABLE [dbo].[ProgramareConsultatie] (
    [idProgramare] INT           IDENTITY (1, 1) NOT NULL,
    [idPersoana]   INT           NOT NULL,
    [Data]         DATETIME      CONSTRAINT [DF_ProgramareConsultatie_Data] DEFAULT (getdate()) NOT NULL,
    [Ora]          DATETIME      NULL,
    [Observatii]   VARCHAR (300) NULL,
    CONSTRAINT [PK_ProgramareConsultatie] PRIMARY KEY CLUSTERED ([idProgramare] ASC),
    CONSTRAINT [FK_ProgramareConsultatie_Persoane] FOREIGN KEY ([idPersoana]) REFERENCES [dbo].[Persoane] ([IdPersoana])
);

